﻿namespace HRM.CORE
{
    using APP.HELPER.Data.Helper;
    using APP.HELPER.Utils.CustomizeToolbox;
    using DevExpress.XtraEditors;
    using DevExpress.XtraEditors.Repository;
    using System; using Extra.ERP;
    using System.ComponentModel;
    using System.Data;
    using System.Data.SqlClient;
    using System.Windows.Forms; using Common;

    public class HRM_SALARY_TABLELIST
    {
        private double m_HealthInsurance;
        private double m_HealthInsurance1;
        private bool m_IsFinish;
        private bool m_IsLock;
        private int m_Month;
        private int m_OvertimeSaturdayType;
        private Guid m_SalaryTableListID;
        private string m_SalaryTableListName;
        private double m_SocialInsurance;
        private double m_SocialInsurance1;
        private double m_UnemploymentInsurance;
        private double m_UnemploymentInsurance1;
        private int m_Year;

        public HRM_SALARY_TABLELIST()
        {
            this.m_SalaryTableListID = Guid.NewGuid();
            this.m_SalaryTableListName = "";
            this.m_Month = 0;
            this.m_Year = 0;
            this.m_SocialInsurance = 0.0;
            this.m_HealthInsurance = 0.0;
            this.m_UnemploymentInsurance = 0.0;
            this.m_SocialInsurance1 = 0.0;
            this.m_HealthInsurance1 = 0.0;
            this.m_UnemploymentInsurance1 = 0.0;
            this.m_OvertimeSaturdayType = 0;
            this.m_IsLock = true;
            this.m_IsFinish = true;
        }

        public HRM_SALARY_TABLELIST(Guid SalaryTableListID, string SalaryTableListName, int Month, int Year, double SocialInsurance, double HealthInsurance, double UnemploymentInsurance, double SocialInsurance1, double HealthInsurance1, double UnemploymentInsurance1, int OvertimeSaturdayType, bool IsLock, bool IsFinish)
        {
            this.m_SalaryTableListID = SalaryTableListID;
            this.m_SalaryTableListName = SalaryTableListName;
            this.m_Month = Month;
            this.m_Year = Year;
            this.m_SocialInsurance = SocialInsurance;
            this.m_HealthInsurance = HealthInsurance;
            this.m_UnemploymentInsurance = UnemploymentInsurance;
            this.m_SocialInsurance1 = SocialInsurance1;
            this.m_HealthInsurance1 = HealthInsurance1;
            this.m_UnemploymentInsurance1 = UnemploymentInsurance1;
            this.m_OvertimeSaturdayType = OvertimeSaturdayType;
            this.m_IsLock = IsLock;
            this.m_IsFinish = IsFinish;
        }

        public void AddCombo(System.Windows.Forms.ComboBox combo)
        {
            GridCalendarControlLib.TableToComboBox(combo, this.GetList(), "SalaryTableListName", "SalaryTableListID");
        }

        public void AddComboAll(System.Windows.Forms.ComboBox combo)
        {
            DataTable list = new DataTable();
            list = this.GetList();
            DataRow row = list.NewRow();
            row["SalaryTableListID"] = "All";
            row["SalaryTableListName"] = "Tất cả";
            list.Rows.InsertAt(row, 0);
            GridCalendarControlLib.TableToComboBox(combo, list, "SalaryTableListName", "SalaryTableListID");
        }

        public void AddComboEdit(ComboBoxEdit combo)
        {
            DataTable list = new DataTable();
            list = this.GetList();
            foreach (DataRow row in list.Rows)
            {
                combo.Properties.Items.Add(row["SalaryTableListName"]);
            }
        }

        public void AddGridLookupEdit(GridLookUpEdit gridlookup)
        {
            DataTable list = new DataTable();
            list = this.GetList();
            gridlookup.Properties.DataSource = list;
            gridlookup.Properties.DisplayMember = "SalaryTableListName";
            gridlookup.Properties.ValueMember = "SalaryTableListID";
        }

        public void AddRepositoryGridLookupEdit(RepositoryItemGridLookUpEdit gridlookup)
        {
            DataTable list = new DataTable();
            list = this.GetList();
            gridlookup.DataSource = list;
            gridlookup.DisplayMember = "SalaryTableListName";
            gridlookup.ValueMember = "SalaryTableListID";
        }

        public string Delete()
        {
            string[] myParams = new string[] { "@SalaryTableListID" };
            object[] myValues = new object[] { this.m_SalaryTableListID };
            SqlHelper helper = new SqlHelper();
            return helper.ExecuteNonQuery("HRM_SALARY_TABLELIST_Delete", myParams, myValues);
        }

        public string Delete(string SalaryTableListID)
        {
            string[] myParams = new string[] { "@SalaryTableListID" };
            object[] myValues = new object[] { SalaryTableListID };
            SqlHelper helper = new SqlHelper();
            return helper.ExecuteNonQuery("HRM_SALARY_TABLELIST_Delete", myParams, myValues);
        }

        public string Delete(SqlConnection myConnection, string SalaryTableListID)
        {
            string[] myParams = new string[] { "@SalaryTableListID" };
            object[] myValues = new object[] { SalaryTableListID };
            SqlHelper helper = new SqlHelper();
            return helper.ExecuteNonQuery(myConnection, "HRM_SALARY_TABLELIST_Delete", myParams, myValues);
        }

        public string Delete(SqlTransaction myTransaction, string SalaryTableListID)
        {
            string[] myParams = new string[] { "@SalaryTableListID" };
            object[] myValues = new object[] { SalaryTableListID };
            SqlHelper helper = new SqlHelper();
            return helper.ExecuteNonQuery(myTransaction, "HRM_SALARY_TABLELIST_Delete", myParams, myValues);
        }

        public bool Exist(int Month, int Year)
        {
            bool hasRows = false;
            string[] myParams = new string[] { "@Month", "@Year" };
            object[] myValues = new object[] { Month, Year };
            SqlHelper helper = new SqlHelper();
            SqlDataReader reader = helper.ExecuteReader("HRM_SALARY_TABLELIST_Get", myParams, myValues);
            if (reader != null)
            {
                hasRows = reader.HasRows;
                reader.Close();
                helper.Close();
                reader = null;
            }
            return hasRows;
        }

        public string Finish(Guid SalaryTableListID)
        {
            string[] myParams = new string[] { "@SalaryTableListID" };
            object[] myValues = new object[] { SalaryTableListID };
            SqlHelper helper = new SqlHelper {
                CommandType = CommandType.Text
            };
            return helper.ExecuteNonQuery("Update HRM_SALARY_TABLELIST set IsLock='1',IsFinish='1' Where SalaryTableListID=@SalaryTableListID", myParams, myValues);
        }

        public string Get(int Month, int Year)
        {
            string str = "";
            string[] myParams = new string[] { "@Month", "@Year" };
            object[] myValues = new object[] { Month, Year };
            SqlHelper helper = new SqlHelper();
            SqlDataReader reader = helper.ExecuteReader("HRM_SALARY_TABLELIST_Get", myParams, myValues);
            if (reader != null)
            {
                while (reader.Read())
                {
                    this.m_SalaryTableListID = reader.GetGuid(reader.GetOrdinal("SalaryTableListID"));
                    this.m_SalaryTableListName = Convert.ToString(reader["SalaryTableListName"]);
                    this.m_Month = Convert.ToInt32(reader["Month"]);
                    this.m_Year = Convert.ToInt32(reader["Year"]);
                    this.m_SocialInsurance = Convert.ToDouble(reader["SocialInsurance"]);
                    this.m_HealthInsurance = Convert.ToDouble(reader["HealthInsurance"]);
                    this.m_UnemploymentInsurance = Convert.ToDouble(reader["UnemploymentInsurance"]);
                    this.m_SocialInsurance1 = Convert.ToDouble(reader["SocialInsurance1"]);
                    this.m_HealthInsurance1 = Convert.ToDouble(reader["HealthInsurance1"]);
                    this.m_UnemploymentInsurance1 = Convert.ToDouble(reader["UnemploymentInsurance1"]);
                    this.m_OvertimeSaturdayType = Convert.ToInt32(reader["OvertimeSaturdayType"]);
                    this.m_IsLock = Convert.ToBoolean(reader["IsLock"]);
                    this.m_IsFinish = Convert.ToBoolean(reader["IsFinish"]);
                    str = "OK";
                }
                reader.Close();
                helper.Close();
                reader = null;
            }
            return str;
        }

        public string Get(SqlConnection myConnection, int Month, int Year)
        {
            string str = "";
            string[] myParams = new string[] { "@Month", "@Year" };
            object[] myValues = new object[] { Month, Year };
            SqlHelper helper = new SqlHelper();
            SqlDataReader reader = helper.ExecuteReader(myConnection, "HRM_SALARY_TABLELIST_Get", myParams, myValues);
            if (reader != null)
            {
                while (reader.Read())
                {
                    this.m_SalaryTableListID = reader.GetGuid(reader.GetOrdinal("SalaryTableListID"));
                    this.m_SalaryTableListName = Convert.ToString(reader["SalaryTableListName"]);
                    this.m_Month = Convert.ToInt32(reader["Month"]);
                    this.m_Year = Convert.ToInt32(reader["Year"]);
                    this.m_SocialInsurance = Convert.ToDouble(reader["SocialInsurance"]);
                    this.m_HealthInsurance = Convert.ToDouble(reader["HealthInsurance"]);
                    this.m_UnemploymentInsurance = Convert.ToDouble(reader["UnemploymentInsurance"]);
                    this.m_SocialInsurance1 = Convert.ToDouble(reader["SocialInsurance1"]);
                    this.m_HealthInsurance1 = Convert.ToDouble(reader["HealthInsurance1"]);
                    this.m_UnemploymentInsurance1 = Convert.ToDouble(reader["UnemploymentInsurance1"]);
                    this.m_OvertimeSaturdayType = Convert.ToInt32(reader["OvertimeSaturdayType"]);
                    this.m_IsLock = Convert.ToBoolean(reader["IsLock"]);
                    this.m_IsFinish = Convert.ToBoolean(reader["IsFinish"]);
                    str = "OK";
                }
                reader.Close();
                helper.Close();
                reader = null;
            }
            return str;
        }

        public string Get(SqlTransaction myTransaction, int Month, int Year)
        {
            string str = "";
            string[] myParams = new string[] { "@Month", "@Year" };
            object[] myValues = new object[] { Month, Year };
            SqlHelper helper = new SqlHelper();
            SqlDataReader reader = helper.ExecuteReader(myTransaction, "HRM_SALARY_TABLELIST_Get", myParams, myValues);
            if (reader != null)
            {
                while (reader.Read())
                {
                    this.m_SalaryTableListID = reader.GetGuid(reader.GetOrdinal("SalaryTableListID"));
                    this.m_SalaryTableListName = Convert.ToString(reader["SalaryTableListName"]);
                    this.m_Month = Convert.ToInt32(reader["Month"]);
                    this.m_Year = Convert.ToInt32(reader["Year"]);
                    this.m_SocialInsurance = Convert.ToDouble(reader["SocialInsurance"]);
                    this.m_HealthInsurance = Convert.ToDouble(reader["HealthInsurance"]);
                    this.m_UnemploymentInsurance = Convert.ToDouble(reader["UnemploymentInsurance"]);
                    this.m_SocialInsurance1 = Convert.ToDouble(reader["SocialInsurance1"]);
                    this.m_HealthInsurance1 = Convert.ToDouble(reader["HealthInsurance1"]);
                    this.m_UnemploymentInsurance1 = Convert.ToDouble(reader["UnemploymentInsurance1"]);
                    this.m_OvertimeSaturdayType = Convert.ToInt32(reader["OvertimeSaturdayType"]);
                    this.m_IsLock = Convert.ToBoolean(reader["IsLock"]);
                    this.m_IsFinish = Convert.ToBoolean(reader["IsFinish"]);
                    str = "OK";
                }
                reader.Close();
                helper.Close();
                reader = null;
            }
            return str;
        }

        public string GetByID(Guid SalaryTableListID)
        {
            string str = "";
            string[] myParams = new string[] { "@SalaryTableListID" };
            object[] myValues = new object[] { SalaryTableListID };
            SqlHelper helper = new SqlHelper();
            SqlDataReader reader = helper.ExecuteReader("HRM_SALARY_TABLELIST_GetByID", myParams, myValues);
            if (reader != null)
            {
                while (reader.Read())
                {
                    this.m_SalaryTableListID = reader.GetGuid(reader.GetOrdinal("SalaryTableListID"));
                    this.m_SalaryTableListName = Convert.ToString(reader["SalaryTableListName"]);
                    this.m_Month = Convert.ToInt32(reader["Month"]);
                    this.m_Year = Convert.ToInt32(reader["Year"]);
                    this.m_SocialInsurance = Convert.ToDouble(reader["SocialInsurance"]);
                    this.m_HealthInsurance = Convert.ToDouble(reader["HealthInsurance"]);
                    this.m_UnemploymentInsurance = Convert.ToDouble(reader["UnemploymentInsurance"]);
                    this.m_SocialInsurance1 = Convert.ToDouble(reader["SocialInsurance1"]);
                    this.m_HealthInsurance1 = Convert.ToDouble(reader["HealthInsurance1"]);
                    this.m_UnemploymentInsurance1 = Convert.ToDouble(reader["UnemploymentInsurance1"]);
                    this.m_OvertimeSaturdayType = Convert.ToInt32(reader["OvertimeSaturdayType"]);
                    this.m_IsLock = Convert.ToBoolean(reader["IsLock"]);
                    this.m_IsFinish = Convert.ToBoolean(reader["IsFinish"]);
                    str = "OK";
                }
                reader.Close();
                helper.Close();
                reader = null;
            }
            return str;
        }

        public DataTable GetList()
        {
            SqlHelper helper = new SqlHelper();
            return helper.ExecuteDataTable("HRM_SALARY_TABLELIST_GetList");
        }

        public string Insert()
        {
            string[] myParams = new string[] { "@SalaryTableListID", "@SalaryTableListName", "@Month", "@Year", "@SocialInsurance", "@HealthInsurance", "@UnemploymentInsurance", "@SocialInsurance1", "@HealthInsurance1", "@UnemploymentInsurance1", "@OvertimeSaturdayType", "@IsLock", "@IsFinish" };
            object[] myValues = new object[] { this.m_SalaryTableListID, this.m_SalaryTableListName, this.m_Month, this.m_Year, this.m_SocialInsurance, this.m_HealthInsurance, this.m_UnemploymentInsurance, this.m_SocialInsurance1, this.m_HealthInsurance1, this.m_UnemploymentInsurance1, this.m_OvertimeSaturdayType, this.m_IsLock, this.m_IsFinish };
            SqlHelper helper = new SqlHelper();
            return helper.ExecuteNonQuery("HRM_SALARY_TABLELIST_Insert", myParams, myValues);
        }

        public string Insert(SqlTransaction myTransaction)
        {
            string[] myParams = new string[] { "@SalaryTableListID", "@SalaryTableListName", "@Month", "@Year", "@SocialInsurance", "@HealthInsurance", "@UnemploymentInsurance", "@SocialInsurance1", "@HealthInsurance1", "@UnemploymentInsurance1", "@OvertimeSaturdayType", "@IsLock", "@IsFinish" };
            object[] myValues = new object[] { this.m_SalaryTableListID, this.m_SalaryTableListName, this.m_Month, this.m_Year, this.m_SocialInsurance, this.m_HealthInsurance, this.m_UnemploymentInsurance, this.m_SocialInsurance1, this.m_HealthInsurance1, this.m_UnemploymentInsurance1, this.m_OvertimeSaturdayType, this.m_IsLock, this.m_IsFinish };
            SqlHelper helper = new SqlHelper();
            return helper.ExecuteNonQuery(myTransaction, "HRM_SALARY_TABLELIST_Insert", myParams, myValues);
        }

        public string Insert(string SalaryTableListID, string SalaryTableListName, int Month, int Year, double SocialInsurance, double HealthInsurance, double UnemploymentInsurance, double SocialInsurance1, double HealthInsurance1, double UnemploymentInsurance1, int OvertimeSaturdayType, bool IsLock, bool IsFinish)
        {
            string[] myParams = new string[] { "@SalaryTableListID", "@SalaryTableListName", "@Month", "@Year", "@SocialInsurance", "@HealthInsurance", "@UnemploymentInsurance", "@SocialInsurance1", "@HealthInsurance1", "@UnemploymentInsurance1", "@OvertimeSaturdayType", "@IsLock", "@IsFinish" };
            object[] myValues = new object[] { SalaryTableListID, SalaryTableListName, Month, Year, SocialInsurance, HealthInsurance, UnemploymentInsurance, SocialInsurance1, HealthInsurance1, UnemploymentInsurance1, OvertimeSaturdayType, IsLock, IsFinish };
            SqlHelper helper = new SqlHelper();
            return helper.ExecuteNonQuery("HRM_SALARY_TABLELIST_Insert", myParams, myValues);
        }

        public string Insert(SqlConnection myConnection, string SalaryTableListID, string SalaryTableListName, int Month, int Year, double SocialInsurance, double HealthInsurance, double UnemploymentInsurance, double SocialInsurance1, double HealthInsurance1, double UnemploymentInsurance1, int OvertimeSaturdayType, bool IsLock, bool IsFinish)
        {
            string[] myParams = new string[] { "@SalaryTableListID", "@SalaryTableListName", "@Month", "@Year", "@SocialInsurance", "@HealthInsurance", "@UnemploymentInsurance", "@SocialInsurance1", "@HealthInsurance1", "@UnemploymentInsurance1", "@OvertimeSaturdayType", "@IsLock", "@IsFinish" };
            object[] myValues = new object[] { SalaryTableListID, SalaryTableListName, Month, Year, SocialInsurance, HealthInsurance, UnemploymentInsurance, SocialInsurance1, HealthInsurance1, UnemploymentInsurance1, OvertimeSaturdayType, IsLock, IsFinish };
            SqlHelper helper = new SqlHelper();
            return helper.ExecuteNonQuery(myConnection, "HRM_SALARY_TABLELIST_Insert", myParams, myValues);
        }

        public string Insert(SqlTransaction myTransaction, string SalaryTableListID, string SalaryTableListName, int Month, int Year, double SocialInsurance, double HealthInsurance, double UnemploymentInsurance, double SocialInsurance1, double HealthInsurance1, double UnemploymentInsurance1, int OvertimeSaturdayType, bool IsLock, bool IsFinish)
        {
            string[] myParams = new string[] { "@SalaryTableListID", "@SalaryTableListName", "@Month", "@Year", "@SocialInsurance", "@HealthInsurance", "@UnemploymentInsurance", "@SocialInsurance1", "@HealthInsurance1", "@UnemploymentInsurance1", "@OvertimeSaturdayType", "@IsLock", "@IsFinish" };
            object[] myValues = new object[] { SalaryTableListID, SalaryTableListName, Month, Year, SocialInsurance, HealthInsurance, UnemploymentInsurance, SocialInsurance1, HealthInsurance1, UnemploymentInsurance1, OvertimeSaturdayType, IsLock, IsFinish };
            SqlHelper helper = new SqlHelper();
            return helper.ExecuteNonQuery(myTransaction, "HRM_SALARY_TABLELIST_Insert", myParams, myValues);
        }

        public string Lock(Guid SalaryTableListID)
        {
            string[] myParams = new string[] { "@SalaryTableListID" };
            object[] myValues = new object[] { SalaryTableListID };
            SqlHelper helper = new SqlHelper {
                CommandType = CommandType.Text
            };
            return helper.ExecuteNonQuery("Update HRM_SALARY_TABLELIST set IsLock='1' Where SalaryTableListID=@SalaryTableListID", myParams, myValues);
        }

        public string NewID()
        {
            return SqlHelper.GenCode("HRM_SALARY_TABLELIST", "SalaryTableListID", "CV");
        }

        public string Open(Guid SalaryTableListID)
        {
            string[] myParams = new string[] { "@SalaryTableListID" };
            object[] myValues = new object[] { SalaryTableListID };
            SqlHelper helper = new SqlHelper {
                CommandType = CommandType.Text
            };
            return helper.ExecuteNonQuery("Update HRM_SALARY_TABLELIST set IsLock='0'Where SalaryTableListID=@SalaryTableListID", myParams, myValues);
        }

        public string Update()
        {
            string[] myParams = new string[] { "@SalaryTableListID", "@SalaryTableListName", "@Month", "@Year", "@SocialInsurance", "@HealthInsurance", "@UnemploymentInsurance", "@SocialInsurance1", "@HealthInsurance1", "@UnemploymentInsurance1", "@OvertimeSaturdayType", "@IsLock", "@IsFinish" };
            object[] myValues = new object[] { this.m_SalaryTableListID, this.m_SalaryTableListName, this.m_Month, this.m_Year, this.m_SocialInsurance, this.m_HealthInsurance, this.m_UnemploymentInsurance, this.m_SocialInsurance1, this.m_HealthInsurance1, this.m_UnemploymentInsurance1, this.m_OvertimeSaturdayType, this.m_IsLock, this.m_IsFinish };
            SqlHelper helper = new SqlHelper();
            return helper.ExecuteNonQuery("HRM_SALARY_TABLELIST_Update", myParams, myValues);
        }

        public string Update(string SalaryTableListID, string SalaryTableListName, int Month, int Year, double SocialInsurance, double HealthInsurance, double UnemploymentInsurance, double SocialInsurance1, double HealthInsurance1, double UnemploymentInsurance1, int OvertimeSaturdayType, bool IsLock, bool IsFinish)
        {
            string[] myParams = new string[] { "@SalaryTableListID", "@SalaryTableListName", "@Month", "@Year", "@SocialInsurance", "@HealthInsurance", "@UnemploymentInsurance", "@SocialInsurance1", "@HealthInsurance1", "@UnemploymentInsurance1", "@OvertimeSaturdayType", "@IsLock", "@IsFinish" };
            object[] myValues = new object[] { SalaryTableListID, SalaryTableListName, Month, Year, SocialInsurance, HealthInsurance, UnemploymentInsurance, SocialInsurance1, HealthInsurance1, UnemploymentInsurance1, OvertimeSaturdayType, IsLock, IsFinish };
            SqlHelper helper = new SqlHelper();
            return helper.ExecuteNonQuery("HRM_SALARY_TABLELIST_Update", myParams, myValues);
        }

        public string Update(SqlConnection myConnection, string SalaryTableListID, string SalaryTableListName, int Month, int Year, double SocialInsurance, double HealthInsurance, double UnemploymentInsurance, double SocialInsurance1, double HealthInsurance1, double UnemploymentInsurance1, int OvertimeSaturdayType, bool IsLock, bool IsFinish)
        {
            string[] myParams = new string[] { "@SalaryTableListID", "@SalaryTableListName", "@Month", "@Year", "@SocialInsurance", "@HealthInsurance", "@UnemploymentInsurance", "@SocialInsurance1", "@HealthInsurance1", "@UnemploymentInsurance1", "@OvertimeSaturdayType", "@IsLock", "@IsFinish" };
            object[] myValues = new object[] { SalaryTableListID, SalaryTableListName, Month, Year, SocialInsurance, HealthInsurance, UnemploymentInsurance, SocialInsurance1, HealthInsurance1, UnemploymentInsurance1, OvertimeSaturdayType, IsLock, IsFinish };
            SqlHelper helper = new SqlHelper();
            return helper.ExecuteNonQuery(myConnection, "HRM_SALARY_TABLELIST_Update", myParams, myValues);
        }

        public string Update(SqlTransaction myTransaction, string SalaryTableListID, string SalaryTableListName, int Month, int Year, double SocialInsurance, double HealthInsurance, double UnemploymentInsurance, double SocialInsurance1, double HealthInsurance1, double UnemploymentInsurance1, int OvertimeSaturdayType, bool IsLock, bool IsFinish)
        {
            string[] myParams = new string[] { "@SalaryTableListID", "@SalaryTableListName", "@Month", "@Year", "@SocialInsurance", "@HealthInsurance", "@UnemploymentInsurance", "@SocialInsurance1", "@HealthInsurance1", "@UnemploymentInsurance1", "@OvertimeSaturdayType", "@IsLock", "@IsFinish" };
            object[] myValues = new object[] { SalaryTableListID, SalaryTableListName, Month, Year, SocialInsurance, HealthInsurance, UnemploymentInsurance, SocialInsurance1, HealthInsurance1, UnemploymentInsurance1, OvertimeSaturdayType, IsLock, IsFinish };
            SqlHelper helper = new SqlHelper();
            return helper.ExecuteNonQuery(myTransaction, "HRM_SALARY_TABLELIST_Update", myParams, myValues);
        }

        [DisplayName("HealthInsurance"), Category("Column")]
        public double HealthInsurance
        {
            get
            {
                return this.m_HealthInsurance;
            }
            set
            {
                this.m_HealthInsurance = value;
            }
        }

        [DisplayName("HealthInsurance1"), Category("Column")]
        public double HealthInsurance1
        {
            get
            {
                return this.m_HealthInsurance1;
            }
            set
            {
                this.m_HealthInsurance1 = value;
            }
        }

        [Category("Column"), DisplayName("IsFinish")]
        public bool IsFinish
        {
            get
            {
                return this.m_IsFinish;
            }
            set
            {
                this.m_IsFinish = value;
            }
        }

        [Category("Column"), DisplayName("IsLock")]
        public bool IsLock
        {
            get
            {
                return this.m_IsLock;
            }
            set
            {
                this.m_IsLock = value;
            }
        }

        [DisplayName("Month"), Category("Column")]
        public int Month
        {
            get
            {
                return this.m_Month;
            }
            set
            {
                this.m_Month = value;
            }
        }

        [DisplayName("OvertimeSaturdayType"), Category("Column")]
        public int OvertimeSaturdayType
        {
            get
            {
                return this.m_OvertimeSaturdayType;
            }
            set
            {
                this.m_OvertimeSaturdayType = value;
            }
        }

        public string ProductName
        {
            get
            {
                return "Class HRM_SALARY_TABLELIST";
            }
        }

        public string ProductVersion
        {
            get
            {
                return "1.0.0.0";
            }
        }

        [Category("Primary Key"), DisplayName("SalaryTableListID")]
        public Guid SalaryTableListID
        {
            get
            {
                return this.m_SalaryTableListID;
            }
            set
            {
                this.m_SalaryTableListID = value;
            }
        }

        [DisplayName("SalaryTableListName"), Category("Column")]
        public string SalaryTableListName
        {
            get
            {
                return this.m_SalaryTableListName;
            }
            set
            {
                this.m_SalaryTableListName = value;
            }
        }

        [DisplayName("SocialInsurance"), Category("Column")]
        public double SocialInsurance
        {
            get
            {
                return this.m_SocialInsurance;
            }
            set
            {
                this.m_SocialInsurance = value;
            }
        }

        [DisplayName("SocialInsurance1"), Category("Column")]
        public double SocialInsurance1
        {
            get
            {
                return this.m_SocialInsurance1;
            }
            set
            {
                this.m_SocialInsurance1 = value;
            }
        }

        [Category("Column"), DisplayName("UnemploymentInsurance")]
        public double UnemploymentInsurance
        {
            get
            {
                return this.m_UnemploymentInsurance;
            }
            set
            {
                this.m_UnemploymentInsurance = value;
            }
        }

        [DisplayName("UnemploymentInsurance1"), Category("Column")]
        public double UnemploymentInsurance1
        {
            get
            {
                return this.m_UnemploymentInsurance1;
            }
            set
            {
                this.m_UnemploymentInsurance1 = value;
            }
        }

        [Category("Column"), DisplayName("Year")]
        public int Year
        {
            get
            {
                return this.m_Year;
            }
            set
            {
                this.m_Year = value;
            }
        }
    }
}

